<html>
<head>
  <title>gestion</title>
  <link rel="stylesheet" type="text/css" href="dataModel.css">
</head>

<body class="normalFont">
  <table class="summarytable">
    <tr class=summaryhead">
      <th class="summaryheadbackground summaryborder summaryheadtablename">Table Name</th>
      <th class="summaryheadbackground summaryborder summaryheadjavaname">OM Class</th>
      <th class="summaryheadbackground summaryborder summaryheaddescription">Description</th>
    </tr>
    <tr class=summaryrow">
      <td class="summarybackground summaryborder summarytablename"><a href="#groupe" class="link summarytablenamelink">groupe</a></td>
      <td class="summarybackground summaryborder summaryjavaname">Groupe</td>
      <td class="summarybackground summaryborder summarydescription"> table groupe</td>
    </tr>
    <tr class=summaryrow">
      <td class="summarybackground summaryborder summarytablename"><a href="#etudiant" class="link summarytablenamelink">etudiant</a></td>
      <td class="summarybackground summaryborder summaryjavaname">Etudiant</td>
      <td class="summarybackground summaryborder summarydescription"> table etudiant</td>
    </tr>
    <tr class=summaryrow">
      <td class="summarybackground summaryborder summarytablename"><a href="#matieres" class="link summarytablenamelink">matieres</a></td>
      <td class="summarybackground summaryborder summaryjavaname">Matieres</td>
      <td class="summarybackground summaryborder summarydescription"> table matieres</td>
    </tr>
    <tr class=summaryrow">
      <td class="summarybackground summaryborder summarytablename"><a href="#notes" class="link summarytablenamelink">notes</a></td>
      <td class="summarybackground summaryborder summaryjavaname">Notes</td>
      <td class="summarybackground summaryborder summarydescription"> table notes</td>
    </tr>
  </table>

    <a name="groupe"/>
<h2>groupe</h2>
table groupe
<p/>
<table class="detailtable">
  <tr class="detailhead">
    <th class="detailheadbackground detailborder detailheadname">Name</th>
    <th class="detailheadbackground detailborder detailheadtype">Type</th>
    <th class="detailheadbackground detailborder detailheadsize">Size</th>
    <th class="detailheadbackground detailborder detailheaddefault">Default</th>
    <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
    <th class="detailheadbackground detailborder detailheadpk">PK</th>
    <th class="detailheadbackground detailborder detailheadfk">FK</th>
    <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
    <th class="detailheadbackground detailborder detailheaddescription">Description</th>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname primarykey notnull" id="groupegroupe_id">groupe_id</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">GroupeId</td>
    <td class="detailbackground detailborder detailpk"><center> X </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> groupe Id</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname notnull" id="groupenom">nom</td>
    <td class="detailbackground detailborder detailtype">VARCHAR</td>
    <td class="detailbackground detailborder detailsize"> (128) </td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Nom</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> groupe Name</td>
  </tr>
</table>

    <a name="etudiant"/>
<h2>etudiant</h2>
table etudiant
<p/>
<table class="detailtable">
  <tr class="detailhead">
    <th class="detailheadbackground detailborder detailheadname">Name</th>
    <th class="detailheadbackground detailborder detailheadtype">Type</th>
    <th class="detailheadbackground detailborder detailheadsize">Size</th>
    <th class="detailheadbackground detailborder detailheaddefault">Default</th>
    <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
    <th class="detailheadbackground detailborder detailheadpk">PK</th>
    <th class="detailheadbackground detailborder detailheadfk">FK</th>
    <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
    <th class="detailheadbackground detailborder detailheaddescription">Description</th>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname primarykey notnull" id="etudiantetudiant_id">etudiant_id</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">EtudiantId</td>
    <td class="detailbackground detailborder detailpk"><center> X </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> Author Id</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname notnull" id="etudiantnom">nom</td>
    <td class="detailbackground detailborder detailtype">VARCHAR</td>
    <td class="detailbackground detailborder detailsize"> (128) </td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Nom</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> nom</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname notnull" id="etudiantprenom">prenom</td>
    <td class="detailbackground detailborder detailtype">VARCHAR</td>
    <td class="detailbackground detailborder detailsize"> (128) </td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Prenom</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> prenom</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname foreignkey notnull" id="etudiantgroupe_id"><a href="#groupe" title="Foreign key to groupe.groupe_id" class="link detailforeignkeylink">groupe_id</a>
</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">GroupeId</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center> X </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> groupe</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname" id="etudiantnbAbsences">nbAbsences</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Nbabsences</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detaildescription"> nb absences</td>
  </tr>
</table>

    <a name="matieres"/>
<h2>matieres</h2>
table matieres
<p/>
<table class="detailtable">
  <tr class="detailhead">
    <th class="detailheadbackground detailborder detailheadname">Name</th>
    <th class="detailheadbackground detailborder detailheadtype">Type</th>
    <th class="detailheadbackground detailborder detailheadsize">Size</th>
    <th class="detailheadbackground detailborder detailheaddefault">Default</th>
    <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
    <th class="detailheadbackground detailborder detailheadpk">PK</th>
    <th class="detailheadbackground detailborder detailheadfk">FK</th>
    <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
    <th class="detailheadbackground detailborder detailheaddescription">Description</th>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname primarykey notnull" id="matieresmatiere_id">matiere_id</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">MatiereId</td>
    <td class="detailbackground detailborder detailpk"><center> X </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> matiere Id</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname notnull" id="matieresintitule">intitule</td>
    <td class="detailbackground detailborder detailtype">VARCHAR</td>
    <td class="detailbackground detailborder detailsize"> (128) </td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Intitule</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> matiere</td>
  </tr>
</table>

    <a name="notes"/>
<h2>notes</h2>
table notes
<p/>
<table class="detailtable">
  <tr class="detailhead">
    <th class="detailheadbackground detailborder detailheadname">Name</th>
    <th class="detailheadbackground detailborder detailheadtype">Type</th>
    <th class="detailheadbackground detailborder detailheadsize">Size</th>
    <th class="detailheadbackground detailborder detailheaddefault">Default</th>
    <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
    <th class="detailheadbackground detailborder detailheadpk">PK</th>
    <th class="detailheadbackground detailborder detailheadfk">FK</th>
    <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
    <th class="detailheadbackground detailborder detailheaddescription">Description</th>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname primarykey notnull" id="notesnote_id">note_id</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">NoteId</td>
    <td class="detailbackground detailborder detailpk"><center> X </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> note Id</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname foreignkey notnull" id="notesmatiere_id"><a href="#matieres" title="Foreign key to matieres.matiere_id" class="link detailforeignkeylink">matiere_id</a>
</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">MatiereId</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center> X </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> foreignkey matiere</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname notnull" id="notesnote">note</td>
    <td class="detailbackground detailborder detailtype">VARCHAR</td>
    <td class="detailbackground detailborder detailsize"> (128) </td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Note</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> note</td>
  </tr>
  <tr class="detailrow">
    <td class="detailbackground detailborder detailname notnull" id="notescoef">coef</td>
    <td class="detailbackground detailborder detailtype">INTEGER</td>
    <td class="detailbackground detailborder detailsize"> &nbsp;</td>
    <td class="detailbackground detailborder detaildefault"> &nbsp;</td>
    <td class="detailbackground detailborder detailjavaname">Coef</td>
    <td class="detailbackground detailborder detailpk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailfk"><center>  &nbsp; </center></td>
    <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
    <td class="detailbackground detailborder detaildescription"> coef</td>
  </tr>
</table>


</body>
</html>
